<?php
$config["tables"] = array(
	"affiliate" => array(
		"id" => array("type" => "int"),
		"name" => array("type" => "varchar"),
		"count" => array("type" => "int"),
		"price" => array("type" => "int")
	),
	"cache" => array(
		"id" => array("type" => "int"),
		"query" => array("type" => "blob"),
		"path" => array("type" => "text")
	),
	"category" => array(
		"id" => array("type" => "int"),
		"parent_id" => array("type" => "int"),
		"name" => array("type" => "varchar"),
		"imported" => array("type" => "tinyint"),
		"marked_deletion" => array("type" => "tinyint"),
		"language_id" => array("type" => "int"),
		"original_id" => array("type" => "int"),
		"order" => array("type" => "int"),
		"related_category" => array("type" => "int"),
		"display" => array("type" => "int")
	),
	"ci_sessions" => array(
		"session_id" => array("type" => "varchar"),
		"ip_address" => array("type" => "varchar"),
		"user_agent" => array("type" => "varchar"),
		"last_activity" => array("type" => "int"),
		"user_data" => array("type" => "text")
	),
	"countries" => array(
		"id" => array("type" => "int"),
		"name" => array("type" => "varchar"),
		"vat" => array("type" => "decimal"),
		"flag" => array("type" => "varchar"),
		"price_gap" => array("type" => "decimal"),
		"language_id" => array("type" => "int"),
		"currency_id" => array("type" => "int"),
		"code_iso_2" => array("type" => "varchar")
	),
	"curier" => array(
		"id" => array("type" => "int"),
		"name" => array("type" => "varchar"),
		"tax" => array("type" => "int"),
		"web_page" => array("type" => "varchar")
	),
	"currencies" => array(
		"id" => array("type" => "int"),
		"name" => array("type" => "varchar")
	),
	"discount" => array(
		"id" => array("type" => "int"),
		"code" => array("type" => "varchar"),
		"percent" => array("type" => "int"),
		"status" => array("type" => "int")
	),
	"exchange_rates" => array(
		"id" => array("type" => "int"),
		"currency" => array("type" => "int"),
		"value" => array("type" => "double"),
		"date" => array("type" => "date")
	),
	"fe_users" => array(
		"id" => array("type" => "int"),
		"user_email" => array("type" => "varchar"),
		"user_pass" => array("type" => "varchar"),
		"user_date" => array("type" => "datetime"),
		"user_modified" => array("type" => "datetime"),
		"user_last_login" => array("type" => "datetime"),
		"language_id" => array("type" => "int"),
		"first_name" => array("type" => "varchar"),
		"last_name" => array("type" => "varchar"),
		"company" => array("type" => "varchar"),
		"tax_number" => array("type" => "varchar"),
		"country_id" => array("type" => "int"),
		"city" => array("type" => "varchar"),
		"zip" => array("type" => "varchar"),
		"tel" => array("type" => "varchar"),
		"fax" => array("type" => "varchar"),
		"street" => array("type" => "varchar"),
		"newsletter" => array("type" => "int"),
		"discount_code" => array("type" => "varchar")
	),
	"images" => array(
		"id" => array("type" => "int"),
		"url" => array("type" => "varchar"),
		"product_id" => array("type" => "int"),
		"sort" => array("type" => "int")
	),
	"lang_general" => array(
		"id" => array("type" => "int"),
		"key" => array("type" => "varchar"),
		"en" => array("type" => "text"),
		"ro" => array("type" => "text"),
		"es" => array("type" => "text"),
		"sk" => array("type" => "text"),
		"pt" => array("type" => "text"),
		"hu" => array("type" => "text"),
		"fi" => array("type" => "text"),
		"cz" => array("type" => "text"),
		"de" => array("type" => "text"),
		"fr" => array("type" => "text"),
		"it" => array("type" => "text"),
		"sv" => array("type" => "text")
	),
	"languages" => array(
		"id" => array("type" => "int"),
		"key" => array("type" => "varchar"),
		"name" => array("type" => "varchar"),
		"in_front" => array("type" => "tinyint"),
		"order" => array("type" => "tinyint")
	),
	"large_images" => array(
		"id" => array("type" => "int"),
		"url" => array("type" => "varchar"),
		"product_id" => array("type" => "int"),
		"sort" => array("type" => "int")
	),
	"live_view" => array(
		"id" => array("type" => "int"),
		"product_id" => array("type" => "int"),
		"date" => array("type" => "datetime"),
		"ip" => array("type" => "varchar")
	),
	"logs" => array(
		"id" => array("type" => "int"),
		"user_id" => array("type" => "int"),
		"datetime" => array("type" => "datetime")
	),
	"opinions" => array(
		"id" => array("type" => "int"),
		"user_id" => array("type" => "int"),
		"product_id" => array("type" => "int"),
		"date" => array("type" => "datetime"),
		"opinion" => array("type" => "varchar"),
		"published" => array("type" => "int"),
		"language_id" => array("type" => "int")
	),
	"order_address" => array(
		"id" => array("type" => "int"),
		"city" => array("type" => "text"),
		"country_id" => array("type" => "int"),
		"address" => array("type" => "text"),
		"zipp_code" => array("type" => "int"),
		"tel_number" => array("type" => "int"),
		"fax" => array("type" => "int"),
		"company" => array("type" => "text"),
		"state_provide" => array("type" => "text"),
		"type" => array("type" => "int"),
		"first_name" => array("type" => "text"),
		"last_name" => array("type" => "text"),
		"postcode" => array("type" => "text"),
		"user_id" => array("type" => "int"),
		"natural_person" => array("type" => "int"),
		"how_you_found_us" => array("type" => "varchar"),
		"subscribe" => array("type" => "int")
	),
	"orders" => array(
		"id" => array("type" => "int"),
		"products" => array("type" => "text"),
		"data_add" => array("type" => "date"),
		"user_id" => array("type" => "int"),
		"confirmed" => array("type" => "int"),
		"status" => array("type" => "int"),
		"billing_id" => array("type" => "int"),
		"shipping_id" => array("type" => "int"),
		"advance_of_maney" => array("type" => "int"),
		"discount" => array("type" => "int"),
		"shipping_method" => array("type" => "int"),
		"order_type" => array("type" => "int"),
		"language" => array("type" => "int"),
		"country_id" => array("type" => "int"),
		"track_code" => array("type" => "varchar"),
		"affiliate_id" => array("type" => "int"),
		"due_date" => array("type" => "date")
	),
	"product_category_mn" => array(
		"id" => array("type" => "int"),
		"local_id" => array("type" => "int"),
		"foreign_id" => array("type" => "int"),
		"imported" => array("type" => "tinyint"),
		"marked_deletion" => array("type" => "tinyint")
	),
	"product_size_mn" => array(
		"id" => array("type" => "int"),
		"local_id" => array("type" => "int"),
		"foreign_id" => array("type" => "int"),
		"price" => array("type" => "double"),
		"imported" => array("type" => "tinyint")
	),
	"products" => array(
		"id" => array("type" => "int"),
		"sku" => array("type" => "varchar"),
		"parent_id" => array("type" => "int"),
		"language_id" => array("type" => "int"),
		"imported" => array("type" => "tinyint"),
		"attribute_set" => array("type" => "varchar"),
		"name" => array("type" => "varchar"),
		"image" => array("type" => "text"),
		"large_image" => array("type" => "text"),
		"url_key" => array("type" => "text"),
		"url_path" => array("type" => "text"),
		"flash_file_1" => array("type" => "varchar"),
		"flash_file_2" => array("type" => "varchar"),
		"ring_band_width" => array("type" => "varchar"),
		"diamond_size_text" => array("type" => "varchar"),
		"delivery_date" => array("type" => "int"),
		"root_delivery_time" => array("type" => "int"),
		"price" => array("type" => "double"),
		"special_price" => array("type" => "double"),
		"status" => array("type" => "varchar"),
		"carat_weight" => array("type" => "decimal"),
		"colour" => array("type" => "varchar"),
		"metal" => array("type" => "varchar"),
		"shape" => array("type" => "varchar"),
		"setting" => array("type" => "varchar"),
		"certified" => array("type" => "tinyint"),
		"contains_sale_item" => array("type" => "tinyint"),
		"product_type" => array("type" => "varchar"),
		"description" => array("type" => "text"),
		"short_description" => array("type" => "text"),
		"is_in_stock" => array("type" => "tinyint"),
		"low_stock_date" => array("type" => "datetime"),
		"product_name" => array("type" => "varchar"),
		"weight" => array("type" => "double"),
		"clarity" => array("type" => "varchar"),
		"search_width" => array("type" => "varchar"),
		"sync" => array("type" => "tinyint"),
		"sync_date" => array("type" => "datetime"),
		"sync_fields" => array("type" => "text"),
		"marked_deletion" => array("type" => "tinyint"),
		"promotion" => array("type" => "tinyint"),
		"promotion_value" => array("type" => "int"),
		"rating" => array("type" => "decimal"),
		"rate_count" => array("type" => "int")
	),
	"questions" => array(
		"id" => array("type" => "int"),
		"question" => array("type" => "text"),
		"answer" => array("type" => "text"),
		"product_id" => array("type" => "int"),
		"published" => array("type" => "tinyint"),
		"data" => array("type" => "datetime"),
		"user_id" => array("type" => "int"),
		"answered_by" => array("type" => "int"),
		"views" => array("type" => "int"),
		"language_id" => array("type" => "int")
	),
	"site_config" => array(
		"id" => array("type" => "int"),
		"last_updated" => array("type" => "timestamp"),
		"config_key" => array("type" => "varchar"),
		"config_value" => array("type" => "longtext")
	),
	"size" => array(
		"id" => array("type" => "int"),
		"size_uk" => array("type" => "varchar"),
		"size_eu" => array("type" => "decimal"),
		"size_usa" => array("type" => "varchar"),
		"size_japan" => array("type" => "varchar"),
		"gender" => array("type" => "enum"),
		"name_admin" => array("type" => "varchar")
	),
	"user_type" => array(
		"id" => array("type" => "int"),
		"type_name" => array("type" => "varchar")
	),
	"users" => array(
		"id" => array("type" => "int"),
		"user_email" => array("type" => "varchar"),
		"user_pass" => array("type" => "varchar"),
		"user_date" => array("type" => "datetime"),
		"user_modified" => array("type" => "datetime"),
		"user_last_login" => array("type" => "datetime"),
		"type_id" => array("type" => "varchar"),
		"language_id" => array("type" => "int"),
		"user_name" => array("type" => "varchar"),
		"profile_pic" => array("type" => "varchar"),
		"description" => array("type" => "text"),
		"discount_code" => array("type" => "varchar")
	)
);
?>